<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Reports.aspx.cs" Inherits="Reports" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">   
<table cellpadding="5" cellspacing="0" style="width: 100%">
  <tr>
    <td valign="top">
                <table id="Table1" cellpadding="5" cellspacing="0" width="100%">
                    <tr>
                        <td bgcolor="#EBE7E7" colspan="2">Reports</td>
                    </tr>
                    <tr>
                        <td colspan="2" style="height: 24px">
                            <table style="width: 100%" cellpadding="5" cellspacing="0">
                                <tr>
                                    <td bgcolor="#EBE7E7" style="width: 154px">
                                        Instance Count:</td>
                                    <td style="width: 175px">
                                        <asp:Label ID="lblInstanceCount" runat="server"></asp:Label>
                                    </td>
                                    <td>
                                        &nbsp;</td>
                                </tr>
                                <tr>
                                    <td bgcolor="#EBE7E7" style="width: 154px">
                            Database Count:</td>
                                    <td id="lblDatabaseCount" style="width: 175px">
                                        <asp:Label ID="lblDatabaseCount" runat="server"></asp:Label>
                                    </td>
                                    <td id="lblDatabaseCount">
                                        &nbsp;</td>
                                </tr>
                                <tr>
                                    <td bgcolor="#EBE7E7" style="width: 154px">
                                        TotalSizeMB:</td>
                                    <td style="width: 175px">
                                        <asp:Label ID="lblSpaceAllocated" runat="server"></asp:Label>
                                        MB
                                    </td>
                                    <td>
                                        total size of data and log files</td>
                                </tr>
                                <tr>
                                    <td bgcolor="#EBE7E7" style="width: 154px">
                                        DataSizeMB:</td>
                                    <td style="width: 175px">
                                        <asp:Label ID="lblDataSizeMB" runat="server"></asp:Label>
                                        MB
                                    </td>
                                    <td>
                                        total size of data files only</td>
                                </tr>
                                <tr>
                                    <td bgcolor="#EBE7E7" style="width: 154px">
                                        LogSizeMB:</td>
                                    <td style="width: 175px">
                                        <asp:Label ID="lblLogSizeMB" runat="server"></asp:Label>
                                        MB
                                    </td>
                                    <td>
                                        total size of log files only</td>
                                </tr>
                                <tr>
                                    <td bgcolor="#EBE7E7" style="width: 154px">
                                        DataSpaceUsedMB:</td>
                                    <td style="width: 175px">
                                        <asp:Label ID="lblSpaceUsed" runat="server"></asp:Label>
                                        MB
                                    </td>
                                    <td>
                                        total space used data files only</td>
                                </tr>
                            </table>
                            </td>
                    </tr>
                </table>
            </td>
  </tr>
  <tr>
        <td colspan="2" style="height: 24px">
        <asp:GridView ID="gv1" runat="server" AllowSorting="False"
                CellPadding="4" ForeColor="#333333" GridLines="None" Width="100%" 
                AutoGenerateColumns="False">
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" HorizontalAlign=Left />
            <Columns>
            <asp:BoundField DataField="TimeFrame" HeaderText="">
                <ItemStyle HorizontalAlign="Left" />
                <HeaderStyle HorizontalAlign="Left" />
            </asp:BoundField> 
            <asp:BoundField DataField="TotalSizeMB" HeaderText="TotalSizeMB">
                <ItemStyle HorizontalAlign="Left" />
                <HeaderStyle HorizontalAlign="Left" />
            </asp:BoundField>   
            <asp:BoundField DataField="DataSizeMB" HeaderText="DataSizeMB">
                <ItemStyle HorizontalAlign="Left" />
                <HeaderStyle HorizontalAlign="Left" />
            </asp:BoundField>   
            <asp:BoundField DataField="LogSizeMB" HeaderText="LogSizeMB">
                <ItemStyle HorizontalAlign="Left" />
                <HeaderStyle HorizontalAlign="Left" />
            </asp:BoundField> 
            <asp:BoundField DataField="DataSpaceUsedMB" HeaderText="DataSpaceUsedMB">
                <ItemStyle HorizontalAlign="Left" />
                <HeaderStyle HorizontalAlign="Left" />
            </asp:BoundField>                                
        </Columns>
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" HorizontalAlign="Left" />
            <EditRowStyle BackColor="#999999" HorizontalAlign="Left" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#003366" Font-Bold="True" Font-Size="X-Small" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        </asp:GridView>
        </td>
    </tr>
  <tr>
    <td valign="top">
                <table id="Table8" cellpadding="5" cellspacing="0" width="100%">
                    <tr>
                        <td bgcolor="#EBE7E7" colspan="2">Database Space Growth (All)</td>
                    </tr>
                    <tr>
                        <td colspan="2" style="height: 24px">
                            <table cellpadding="0" cellspacing="0" width="100%">
                            </table>
                            <table>
                                <tr>
                                    <td colspan="2">
                                        <asp:Chart ID="chtDay" runat="server" BackColor="#B6D6EC" 
                                            BackGradientStyle="TopBottom" BackSecondaryColor="White" 
                                            BorderlineColor="Black" BorderlineDashStyle="Solid" Height="200" Width="795">
                                            <ChartAreas>
                                                <asp:ChartArea BackGradientStyle="TopBottom" BackSecondaryColor="#B6D6EC" 
                                                    BorderDashStyle="Solid" BorderWidth="2" Name="MonthChartArea">
                                                    <AxisX Interval="1" TextOrientation="Rotated90">
                                                    </AxisX>
                                                </asp:ChartArea>
                                            </ChartAreas>
                                        </asp:Chart>
                                    </td>
                                </tr>
                                <tr>
                                    <td align="left">
                                        <asp:Chart ID="chtMonth" runat="server" BackColor="#B6D6EC" 
                                            BackGradientStyle="TopBottom" BackSecondaryColor="White" 
                                            BorderlineColor="Black" BorderlineDashStyle="Solid" Height="200" Width="500">
                                            <ChartAreas>
                                                <asp:ChartArea BackGradientStyle="TopBottom" BackSecondaryColor="#B6D6EC" 
                                                    BorderDashStyle="Solid" BorderWidth="2" Name="MonthChartArea">
                                                    <AxisX Interval="1" TextOrientation="Rotated90">
                                                    </AxisX>
                                                </asp:ChartArea>
                                            </ChartAreas>
                                        </asp:Chart>
                                    </td>
                                    <td align="right">
                                        <asp:Chart ID="chtYear" runat="server" BackColor="#B6D6EC" 
                                            BackGradientStyle="TopBottom" BackSecondaryColor="White" 
                                            BorderlineColor="Black" BorderlineDashStyle="Solid" Height="200" Width="290">
                                            <ChartAreas>
                                                <asp:ChartArea BackGradientStyle="TopBottom" BackSecondaryColor="#B6D6EC" 
                                                    BorderDashStyle="Solid" BorderWidth="2" Name="YearChartArea">
                                                    <AxisX Interval="1" TextOrientation="Rotated90">
                                                    </AxisX>
                                                </asp:ChartArea>
                                            </ChartAreas>
                                        </asp:Chart>
                                    </td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                </table>
            </td>
  </tr>
  <tr>
    <td valign="top">
                <table id="Table4" cellpadding="5" cellspacing="0" width="100%">
                    <tr>
                        <td bgcolor="#EBE7E7" colspan="2">Top 10 largest databases</td>
                    </tr>
                    <tr>
                        <td colspan="2" style="height: 24px"><asp:GridView ID="gvTop10LargestDatabase" runat="server" AllowSorting="False" AutoGenerateColumns="False"
                                CellPadding="4" ForeColor="#333333" GridLines="None" Width="100%">
                            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                            <Columns>
                                <asp:HyperLinkField DataNavigateUrlFields="InstanceName" DataNavigateUrlFormatString="~/InstanceDetail.aspx?InstanceName={0}" DataTextField="InstanceName" HeaderText="Instance Name" >
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:HyperLinkField>
                                <asp:HyperLinkField DataNavigateUrlFields="InstanceName,DatabaseName" DataNavigateUrlFormatString="~/DatabaseDetail.aspx?InstanceName={0}&DatabaseName={1}" DataTextField="DatabaseName" HeaderText="Database Name" >
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:HyperLinkField>
                                <asp:BoundField DataField="TotalSize(MB)" HeaderText="Size(MB)">
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:BoundField>                                
                            </Columns>
                            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                            <EditRowStyle BackColor="#999999" />
                            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                            <HeaderStyle BackColor="#003366" Font-Bold="True" Font-Size="X-Small" ForeColor="White" />
                            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                        </asp:GridView>
                        </td>
                    </tr>
                </table>
            </td>
  </tr>
  <tr>
    <td valign="top">
                <table id="Table5" cellpadding="5" cellspacing="0" width="100%">
                    <tr>
                        <td bgcolor="#EBE7E7" colspan="2">Top 10 fastest growing databases by size (today compared to 30 
                            days ago)</td>
                    </tr>
                    <tr>
                        <td colspan="2" style="height: 24px"><asp:GridView ID="gvFastestGrowthMonth" runat="server" AllowSorting="False" AutoGenerateColumns="False"
                                CellPadding="4" ForeColor="#333333" GridLines="None" Width="100%">
                            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                            <Columns>
                                <asp:HyperLinkField DataNavigateUrlFields="InstanceName" DataNavigateUrlFormatString="~/InstanceDetail.aspx?InstanceName={0}" DataTextField="InstanceName" HeaderText="Instance Name" >
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:HyperLinkField>
                                <asp:HyperLinkField DataNavigateUrlFields="InstanceName,DatabaseName" DataNavigateUrlFormatString="~/DatabaseDetail.aspx?InstanceName={0}&DatabaseName={1}" DataTextField="DatabaseName" HeaderText="Database Name" >
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:HyperLinkField>
                                <asp:BoundField DataField="Last Month" HeaderText="Last Month">
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:BoundField>   
                                <asp:BoundField DataField="Today" HeaderText="Today">
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:BoundField>   
                                <asp:BoundField DataField="GrowthMB" HeaderText="Growth(MB)">
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:BoundField>                                
                            </Columns>
                            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                            <EditRowStyle BackColor="#999999" />
                            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                            <HeaderStyle BackColor="#003366" Font-Bold="True" Font-Size="X-Small" ForeColor="White" />
                            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                        </asp:GridView>
                        </td>
                    </tr>
                </table>
            </td>
  </tr>
  <tr>
    <td valign="top">
                <table id="Table6" cellpadding="5" cellspacing="0" width="100%">
                    <tr>
                        <td bgcolor="#EBE7E7" colspan="2">Top 10 fastest growing databases by size&nbsp;(today compared to 12 months ago)</td>
                    </tr>
                    <tr>
                        <td colspan="2" style="height: 24px"><asp:GridView ID="gvFastestGrowthYear" runat="server" AllowSorting="False" AutoGenerateColumns="False"
                                CellPadding="4" ForeColor="#333333" GridLines="None" Width="100%">
                            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                            <Columns>
                                <asp:HyperLinkField DataNavigateUrlFields="InstanceName" DataNavigateUrlFormatString="~/InstanceDetail.aspx?InstanceName={0}" DataTextField="InstanceName" HeaderText="Instance Name" >
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:HyperLinkField>
                                <asp:HyperLinkField DataNavigateUrlFields="InstanceName,DatabaseName" DataNavigateUrlFormatString="~/DatabaseDetail.aspx?InstanceName={0}&DatabaseName={1}" DataTextField="DatabaseName" HeaderText="Database Name" >
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:HyperLinkField>
                                <asp:BoundField DataField="Last Year" HeaderText="Last Year">
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:BoundField>   
                                <asp:BoundField DataField="Today" HeaderText="Today">
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:BoundField>   
                                <asp:BoundField DataField="GrowthMB" HeaderText="Growth(MB)">
                                    <ItemStyle HorizontalAlign="Left" />
                                    <HeaderStyle HorizontalAlign="Left" />
                                </asp:BoundField>                                
                            </Columns>
                            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                            <EditRowStyle BackColor="#999999" />
                            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                            <HeaderStyle BackColor="#003366" Font-Bold="True" Font-Size="X-Small" ForeColor="White" />
                            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                        </asp:GridView>
                        </td>
                    </tr>
                </table>
            </td>
  </tr>
</table>
</asp:Content>